/*
 * 版权所有 (C) 2015 知启蒙(ZHIQIM) 保留所有权利。[遇见知启蒙，邂逅框架梦]
 * 
 * https://zhiqim.org/project/zhiqim_components/zhiqim_manager.htm
 *
 * Zhiqim Manager is licensed under Mulan PSL v2.
 * You can use this software according to the terms and conditions of the Mulan PSL v2.
 * You may obtain a copy of Mulan PSL v2 at:
 *          http://license.coscl.org.cn/MulanPSL2
 * THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
 * EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
 * MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
 * See the Mulan PSL v2 for more details.
 */
package org.zhiqim.manager.dao;

import java.sql.SQLException;
import java.util.List;

import org.zhiqim.kernel.annotation.AnAlias;
import org.zhiqim.manager.dbo.ZmrRole;
import org.zhiqim.orm.ORM;
import org.zhiqim.orm.ORMException;
import org.zhiqim.orm.dbo.Selector;

/**
 * 角色数据访问对象
 *
 * @version v1.0.0 @author zouzhigang 2017-8-23 新建与整理
 */
@AnAlias("ZmrRoleDao")
public class ZmrRoleDao
{
    /**
     * 获取角色列表，根据部门排序数、角色编号排序
     * 
     * @return              角色列表
     * @throws ORMException ORM异常
     * @throws SQLException SQL异常
     */
    public static List<ZmrRole> list() throws ORMException, SQLException
    {
        return ORM.table().list(ZmrRole.class, new Selector().addOrderbyAsc("roleSeq,roleId"));
    }
    
    /**
     * 通过角色编号读取角色名称
     * 
     * @param roleId        角色编号
     * @return              角色名称
     * @throws ORMException ORM异常
     * @throws SQLException SQL异常
     */
    public static String name(long roleId) throws ORMException, SQLException
    { 
        ZmrRole item = ORM.table().item(ZmrRole.class, roleId);
        return (item == null)?null:item.getRoleName();
    }
}
